﻿using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Text;

namespace EFModel
{
    public class MyDBContext : DbContext
    {
        public MyDBContext(DbContextOptions<MyDBContext> options) : base(options)
        {
            //this.Database.EnsureCreated();

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            var onfig_file_first_kind = modelBuilder.Entity<config_file_first_kind>();
            onfig_file_first_kind.ToTable("config_file_first_kind");//映射的表名
            //配置表中的列名设置
            onfig_file_first_kind.Property(e => e.first_kind_id);
            onfig_file_first_kind.Property(e => e.first_kind_name).HasMaxLength(20);
            onfig_file_first_kind.Property(e => e.first_kind_salary_id);
            onfig_file_first_kind.Property(e => e.first_kind_sale_id);
            //配置表中的种子数据
            //onfig_file_first_kind.HasData(new config_file_first_kind[] {
            //  new config_file_first_kind(){ ffk_id=1,first_kind_id=1,first_kind_name="集团",first_kind_salary_id=1,first_kind_sale_id=1}
            //});

            var onfig_file_second_kind = modelBuilder.Entity<config_file_second_kind>();
            onfig_file_second_kind.ToTable("config_file_second_kind");//映射的表名
            //配置表中的列名设置
            onfig_file_second_kind.Property(e => e.second_kind_id);
            onfig_file_second_kind.Property(e => e.second_kind_name).HasMaxLength(30);
            onfig_file_second_kind.Property(e => e.second_salary_id);
            onfig_file_second_kind.Property(e => e.second_sale_id);
            onfig_file_second_kind.Property(e => e.first_kind_name).HasMaxLength(30);
            onfig_file_second_kind.HasOne(e => e.config_file_first_kind).WithMany().HasForeignKey(e => e.first_kind_id).IsRequired();

            var onfig_file_third_kind = modelBuilder.Entity<config_file_third_kind>();
            onfig_file_third_kind.ToTable("config_file_third_kind");//映射的表名
            //配置表中的列名设置
            onfig_file_third_kind.Property(e => e.second_kind_id);
            onfig_file_third_kind.Property(e => e.third_kind_id);
            onfig_file_third_kind.Property(e => e.third_kind_is_retail).HasMaxLength(30);
            onfig_file_third_kind.Property(e => e.third_kind_name).HasMaxLength(30);
            onfig_file_third_kind.Property(e => e.third_kind_sale_id);
            onfig_file_third_kind.Property(e => e.first_kind_name).HasMaxLength(30);
            onfig_file_third_kind.Property(e => e.second_kind_name).HasMaxLength(30);
            onfig_file_third_kind.HasOne(e => e.config_file_first_kind).WithMany().HasForeignKey(e => e.first_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            onfig_file_third_kind.HasOne(e => e.config_file_second_kind).WithMany().HasForeignKey(e => e.second_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var onfig_major = modelBuilder.Entity<config_major>();
            onfig_major.ToTable("config_major");//映射的表名
            //配置表中的列名设置
            onfig_major.Property(e => e.major_name).HasMaxLength(30);
            onfig_major.Property(e => e.major_id);
            onfig_major.Property(e => e.test_amount);
            onfig_major.Property(e => e.major_kind_name).HasMaxLength(30);
            onfig_major.HasOne(e => e.config_major_kind).WithMany().HasForeignKey(e => e.major_kind_id).IsRequired();

            var onfig_major_kind = modelBuilder.Entity<config_major_kind>();
            onfig_major_kind.ToTable("config_major_kind");//映射的表名
            //配置表中的列名设置
            onfig_major_kind.Property(e => e.major_kind_id);
            onfig_major_kind.Property(e => e.major_kind_name).HasMaxLength(30);

            var onfig_public_char = modelBuilder.Entity<config_public_char>();
            onfig_public_char.ToTable("config_public_char");//映射的表名
            //配置表中的列名设置
            onfig_public_char.Property(e => e.attribute_kind);
            onfig_public_char.Property(e => e.attribute_name).HasMaxLength(30);

            var otype = modelBuilder.Entity<type>();
            otype.ToTable("type");//映射的表名
            //配置表中的列名设置
            otype.Property(e => e.icon).HasMaxLength(30);
            otype.Property(e => e.name).HasMaxLength(30);
            otype.Property(e => e.path).HasMaxLength(30);
            otype.Property(e => e.pid);

            var ousers = modelBuilder.Entity<users>();
            ousers.ToTable("users");//映射的表名
            //配置表中的列名设置
            ousers.Property(e => e.u_name).HasMaxLength(30);
            ousers.Property(e => e.u_password).HasMaxLength(30);
            ousers.Property(e => e.u_true_name).HasMaxLength(30);
            ousers.HasOne(e => e.Role).WithMany().HasForeignKey(e => e.RoleID).IsRequired();

            var ngage_major_release = modelBuilder.Entity<engage_major_release>();
            ngage_major_release.ToTable("engage_major_release");//映射的表名
            //配置表中的列名设置
            ngage_major_release.Property(e => e.first_kind_name).HasMaxLength(30);
            ngage_major_release.Property(e => e.second_kind_name).HasMaxLength(30);
            ngage_major_release.Property(e => e.third_kind_name).HasMaxLength(30);
            ngage_major_release.Property(e => e.major_kind_name).HasMaxLength(30);
            ngage_major_release.Property(e => e.major_name).HasMaxLength(30);
            ngage_major_release.Property(e => e.human_amount);
            ngage_major_release.Property(e => e.engage_type).HasMaxLength(30);
            ngage_major_release.Property(e => e.deadline);
            ngage_major_release.Property(e => e.register).HasMaxLength(30);
            ngage_major_release.Property(e => e.changer).HasMaxLength(30);
            ngage_major_release.Property(e => e.regist_time);
            ngage_major_release.Property(e => e.change_time);
            ngage_major_release.Property(e => e.major_describe).HasMaxLength(30);
            ngage_major_release.Property(e => e.engage_required).HasMaxLength(30);
            ngage_major_release.HasOne(e => e.config_file_first_kind).WithMany().HasForeignKey(e => e.first_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_major_release.HasOne(e => e.config_file_second_kind).WithMany().HasForeignKey(e => e.second_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_major_release.HasOne(e => e.config_file_third_kind).WithMany().HasForeignKey(e => e.third_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_major_release.HasOne(e => e.config_major_kind).WithMany().HasForeignKey(e => e.major_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_major_release.HasOne(e => e.config_major).WithMany().HasForeignKey(e => e.major_id).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var ngage_resume = modelBuilder.Entity<engage_resume>();
            ngage_resume.ToTable("engage_resume");//映射的表名
            //配置表中的列名设置
            ngage_resume.Property(e => e.human_name).HasMaxLength(30);
            ngage_resume.Property(e => e.engage_type).HasMaxLength(30);
            ngage_resume.Property(e => e.human_address).HasMaxLength(30);
            ngage_resume.Property(e => e.human_postcode).HasMaxLength(30);
            ngage_resume.Property(e => e.human_major_kind_name).HasMaxLength(30);
            ngage_resume.Property(e => e.human_major_name).HasMaxLength(30);
            ngage_resume.Property(e => e.human_telephone).HasMaxLength(30);
            ngage_resume.Property(e => e.human_homephone).HasMaxLength(30);
            ngage_resume.Property(e => e.human_mobilephone).HasMaxLength(30);
            ngage_resume.Property(e => e.human_email).HasMaxLength(30);
            ngage_resume.Property(e => e.human_hobby).HasMaxLength(30);
            ngage_resume.Property(e => e.human_specility).HasMaxLength(30);
            ngage_resume.Property(e => e.human_sex).HasMaxLength(30);
            ngage_resume.Property(e => e.human_religion).HasMaxLength(30);
            ngage_resume.Property(e => e.human_party).HasMaxLength(30);
            ngage_resume.Property(e => e.human_nationality).HasMaxLength(30);
            ngage_resume.Property(e => e.human_race).HasMaxLength(30);
            ngage_resume.Property(e => e.human_birthday);
            ngage_resume.Property(e => e.human_age);
            ngage_resume.Property(e => e.human_educated_degree).HasMaxLength(30);
            ngage_resume.Property(e => e.human_educated_years);
            ngage_resume.Property(e => e.human_educated_major).HasMaxLength(30);
            ngage_resume.Property(e => e.human_college).HasMaxLength(30);
            ngage_resume.Property(e => e.human_idcard).HasMaxLength(30);
            ngage_resume.Property(e => e.human_birthplace).HasMaxLength(30);
            ngage_resume.Property(e => e.demand_salary_standard);
            ngage_resume.Property(e => e.human_history_records).HasMaxLength(30);
            ngage_resume.Property(e => e.remark).HasMaxLength(30);
            ngage_resume.Property(e => e.recomandation).HasMaxLength(30);
            ngage_resume.Property(e => e.human_picture).HasMaxLength(10000);
            ngage_resume.Property(e => e.attachment_name).HasMaxLength(30);
            ngage_resume.Property(e => e.check_status);
            ngage_resume.Property(e => e.register).HasMaxLength(30);
            ngage_resume.Property(e => e.regist_time);
            ngage_resume.Property(e => e.checker).HasMaxLength(30);
            ngage_resume.Property(e => e.check_time);
            ngage_resume.Property(e => e.interview_status);
            ngage_resume.Property(e => e.total_points);
            ngage_resume.Property(e => e.test_amount);
            ngage_resume.Property(e => e.test_checker).HasMaxLength(30);
            ngage_resume.Property(e => e.test_check_time);
            ngage_resume.Property(e => e.pass_register).HasMaxLength(30);
            ngage_resume.Property(e => e.pass_regist_time).HasMaxLength(30);
            ngage_resume.Property(e => e.pass_checker).HasMaxLength(30);
            ngage_resume.Property(e => e.pass_check_time);
            ngage_resume.Property(e => e.pass_check_status);
            ngage_resume.Property(e => e.pass_checkComment).HasMaxLength(300);
            ngage_resume.Property(e => e.pass_passComment).HasMaxLength(300);
            ngage_resume.HasOne(e => e.config_major_kind).WithMany().HasForeignKey(e => e.human_major_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_resume.HasOne(e => e.config_major).WithMany().HasForeignKey(e => e.human_major_id).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var ngage_interview = modelBuilder.Entity<engage_interview>();
            ngage_interview.ToTable("engage_interview");//映射的表名
            //配置表中的列名设置
            ngage_interview.Property(e => e.human_name).HasMaxLength(300);
            ngage_interview.Property(e => e.interview_amount);
            ngage_interview.Property(e => e.human_major_kind_name).HasMaxLength(300);
            ngage_interview.Property(e => e.human_major_name).HasMaxLength(300);
            ngage_interview.Property(e => e.image_degree).HasMaxLength(30);
            ngage_interview.Property(e => e.native_language_degree).HasMaxLength(300);
            ngage_interview.Property(e => e.foreign_language_degree).HasMaxLength(300);
            ngage_interview.Property(e => e.response_speed_degree).HasMaxLength(300);
            ngage_interview.Property(e => e.EQ_degree).HasMaxLength(300);
            ngage_interview.Property(e => e.IQ_degree).HasMaxLength(300);
            ngage_interview.Property(e => e.multi_quality_degree).HasMaxLength(300);
            ngage_interview.Property(e => e.register).HasMaxLength(300);
            ngage_interview.Property(e => e.checker).HasMaxLength(30);
            ngage_interview.Property(e => e.registe_time);
            ngage_interview.Property(e => e.check_time);
            ngage_interview.Property(e => e.result).HasMaxLength(300);
            ngage_interview.Property(e => e.interview_comment).HasMaxLength(300);
            ngage_interview.Property(e => e.check_comment).HasMaxLength(300);
            ngage_interview.Property(e => e.interview_status);
            ngage_interview.Property(e => e.check_status);
            ngage_interview.HasOne(e => e.config_major_kind).WithMany().HasForeignKey(e => e.human_major_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_interview.HasOne(e => e.config_major).WithMany().HasForeignKey(e => e.human_major_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            ngage_interview.HasOne(e => e.engage_resume).WithMany().HasForeignKey(e => e.resume_id).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var Role = modelBuilder.Entity<Role>();
            Role.ToTable("Role");//映射的表名
            //配置表中的列名设置
            Role.Property(e => e.Rolename).HasMaxLength(30);
            Role.Property(e => e.Texs).HasMaxLength(300);
            Role.Property(e => e.Ysn);

            var RolPermissions = modelBuilder.Entity<RolPermissions>();
            RolPermissions.ToTable("RolPermissions");//映射的表名
            //配置表中的列名设置
            RolPermissions.HasOne(e => e.Role).WithMany().HasForeignKey(e => e.RoleID).OnDelete(DeleteBehavior.Restrict).IsRequired();
            RolPermissions.HasOne(e => e.type).WithMany().HasForeignKey(e => e.PermissionsID).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var human_file = modelBuilder.Entity<human_file>();
            human_file.ToTable("human_file");//映射的表名
            //配置表中的列名设置
            human_file.Property(e => e.human_id).HasMaxLength(300);
            human_file.Property(e => e.first_kind_name).HasMaxLength(300);
            human_file.Property(e => e.second_kind_name).HasMaxLength(300);
            human_file.Property(e => e.third_kind_name).HasMaxLength(300);
            human_file.Property(e => e.human_name).HasMaxLength(300);
            human_file.Property(e => e.human_address).HasMaxLength(300);
            human_file.Property(e => e.human_postcode).HasMaxLength(300);
            human_file.Property(e => e.human_pro_designation).HasMaxLength(300);
            human_file.Property(e => e.human_major_kind_name).HasMaxLength(300);
            human_file.Property(e => e.hunma_major_name).HasMaxLength(300);
            human_file.Property(e => e.human_telephone).HasMaxLength(300);
            human_file.Property(e => e.human_mobilephone).HasMaxLength(300);
            human_file.Property(e => e.human_bank).HasMaxLength(300);
            human_file.Property(e => e.human_account).HasMaxLength(300);
            human_file.Property(e => e.human_qq).HasMaxLength(300);
            human_file.Property(e => e.human_email).HasMaxLength(300);
            human_file.Property(e => e.human_hobby).HasMaxLength(300);
            human_file.Property(e => e.human_speciality).HasMaxLength(300);
            human_file.Property(e => e.human_sex).HasMaxLength(300);
            human_file.Property(e => e.human_religion).HasMaxLength(300);
            human_file.Property(e => e.human_party).HasMaxLength(300);
            human_file.Property(e => e.human_nationality).HasMaxLength(300);
            human_file.Property(e => e.human_race).HasMaxLength(300);
            human_file.Property(e => e.human_birthday);
            human_file.Property(e => e.human_birthplace).HasMaxLength(300);
            human_file.Property(e => e.human_age);
            human_file.Property(e => e.human_educated_degree).HasMaxLength(300);
            human_file.Property(e => e.human_educated_years);
            human_file.Property(e => e.human_educated_major).HasMaxLength(300);
            human_file.Property(e => e.human_society_security_id).HasMaxLength(300);
            human_file.Property(e => e.human_id_card).HasMaxLength(300);
            human_file.Property(e => e.remark).HasMaxLength(300);
            human_file.Property(e => e.salary_standard_id).HasMaxLength(300);
            human_file.Property(e => e.salary_standard_name).HasMaxLength(300);
            human_file.Property(e => e.salary_sum);
            human_file.Property(e => e.demand_salaray_sum);
            human_file.Property(e => e.paid_salary_sum);
            human_file.Property(e => e.major_change_amount);
            human_file.Property(e => e.bonus_amount);
            human_file.Property(e => e.training_amount);
            human_file.Property(e => e.file_chang_amount);
            human_file.Property(e => e.human_histroy_records).HasMaxLength(300);
            human_file.Property(e => e.human_family_membership).HasMaxLength(300);
            human_file.Property(e => e.human_picture).HasMaxLength(300);
            human_file.Property(e => e.attachment_name).HasMaxLength(300);
            human_file.Property(e => e.check_status);
            human_file.Property(e => e.register).HasMaxLength(300);
            human_file.Property(e => e.checker).HasMaxLength(300);
            human_file.Property(e => e.changer).HasMaxLength(300);
            human_file.Property(e => e.regist_time);
            human_file.Property(e => e.check_time);
            human_file.Property(e => e.change_time);
            human_file.Property(e => e.lastly_change_time);
            human_file.Property(e => e.delete_time);
            human_file.Property(e => e.recovery_time);
            human_file.Property(e => e.human_file_status);
            human_file.HasOne(e => e.config_file_first_kind).WithMany().HasForeignKey(e => e.first_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            human_file.HasOne(e => e.config_file_second_kind).WithMany().HasForeignKey(e => e.second_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            human_file.HasOne(e => e.config_file_third_kind).WithMany().HasForeignKey(e => e.third_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            human_file.HasOne(e => e.config_major_kind).WithMany().HasForeignKey(e => e.human_major_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            human_file.HasOne(e => e.config_major).WithMany().HasForeignKey(e => e.human_major_id).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var salary_standard_details = modelBuilder.Entity<salary_standard_details>();
            salary_standard_details.ToTable("salary_standard_details");//映射的表名
            //配置表中的列名设置
            salary_standard_details.Property(e => e.standard_id).HasMaxLength(300);
            salary_standard_details.Property(e => e.standard_name).HasMaxLength(300);
            salary_standard_details.Property(e => e.item_name).HasMaxLength(300);
            salary_standard_details.Property(e => e.salary);
            salary_standard_details.HasOne(e => e.config_public_char).WithMany().HasForeignKey(e => e.item_id).IsRequired();

            var salary_standard = modelBuilder.Entity<salary_standard>();
            salary_standard.ToTable("salary_standard");//映射的表名
            //配置表中的列名设置
            salary_standard.Property(e => e.standard_id).HasMaxLength(300);
            salary_standard.Property(e => e.standard_name).HasMaxLength(300);
            salary_standard.Property(e => e.designer).HasMaxLength(300);
            salary_standard.Property(e => e.register).HasMaxLength(300);
            salary_standard.Property(e => e.checker).HasMaxLength(300);
            salary_standard.Property(e => e.changer).HasMaxLength(300);
            salary_standard.Property(e => e.regist_time);
            salary_standard.Property(e => e.check_time);
            salary_standard.Property(e => e.change_time);
            salary_standard.Property(e => e.salary_sum);
            salary_standard.Property(e => e.check_status);
            salary_standard.Property(e => e.change_status);
            salary_standard.Property(e => e.check_comment).HasMaxLength(300);
            salary_standard.Property(e => e.remark).HasMaxLength(300);

            var major_change = modelBuilder.Entity<major_change>();
            major_change.ToTable("major_change");//映射的表名
            //配置表中的列名设置
            major_change.Property(e => e.first_kind_name).HasMaxLength(300);
            major_change.Property(e => e.second_kind_name).HasMaxLength(300);
            major_change.Property(e => e.third_kind_name).HasMaxLength(300);
            major_change.Property(e => e.major_kind_name).HasMaxLength(300);
            major_change.Property(e => e.major_name).HasMaxLength(300);
            major_change.Property(e => e.new_first_kind_name).HasMaxLength(300);
            major_change.Property(e => e.new_second_kind_name).HasMaxLength(300);
            major_change.Property(e => e.new_third_kind_name).HasMaxLength(300);
            major_change.Property(e => e.new_major_kind_name).HasMaxLength(300);
            major_change.Property(e => e.new_major_name).HasMaxLength(300);
            major_change.Property(e => e.human_id).HasMaxLength(300);
            major_change.Property(e => e.human_name).HasMaxLength(300);
            major_change.Property(e => e.salary_standard_id).HasMaxLength(3000);
            major_change.Property(e => e.salary_standard_name).HasMaxLength(300);
            major_change.Property(e => e.salary_sum);
            major_change.Property(e => e.new_salary_standard_id).HasMaxLength(3000);
            major_change.Property(e => e.new_salary_standard_name).HasMaxLength(300);
            major_change.Property(e => e.new_salary_sum);
            major_change.Property(e => e.change_reason).HasMaxLength(300);
            major_change.Property(e => e.check_reason).HasMaxLength(300);
            major_change.Property(e => e.check_status);
            major_change.Property(e => e.register).HasMaxLength(300);
            major_change.Property(e => e.checker).HasMaxLength(300);
            major_change.Property(e => e.regist_time);
            major_change.Property(e => e.check_time);
            major_change.HasOne(e => e.config_file_first_kind).WithMany().HasForeignKey(e => e.new_first_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            major_change.HasOne(e => e.config_file_third_kind).WithMany().HasForeignKey(e => e.new_third_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            major_change.HasOne(e => e.config_major).WithMany().HasForeignKey(e => e.new_major_id).OnDelete(DeleteBehavior.Restrict).IsRequired();
            major_change.HasOne(e => e.config_major_kind).WithMany().HasForeignKey(e => e.new_major_kind_id).OnDelete(DeleteBehavior.Restrict).IsRequired();

            var salary_grant = modelBuilder.Entity<salary_grant>();
            salary_grant.ToTable("salary_grant");//映射的表名
            //配置表中的列名设置
            salary_grant.Property(e => e.salary_grant_id).HasMaxLength(300);
            salary_grant.Property(e => e.salary_standard_id).HasMaxLength(300);
            salary_grant.Property(e => e.first_kind_id);
            salary_grant.Property(e => e.first_kind_name).HasMaxLength(300);
            salary_grant.Property(e => e.second_kind_id);
            salary_grant.Property(e => e.second_kind_name).HasMaxLength(300);
            salary_grant.Property(e => e.third_kind_id);
            salary_grant.Property(e => e.third_kind_name).HasMaxLength(300);
            salary_grant.Property(e => e.human_amount);
            salary_grant.Property(e => e.salary_standard_sum);
            salary_grant.Property(e => e.salary_paid_sum);
            salary_grant.Property(e => e.register).HasMaxLength(300);
            salary_grant.Property(e => e.regist_time);
            salary_grant.Property(e => e.checker).HasMaxLength(300);
            salary_grant.Property(e => e.check_time);
            salary_grant.Property(e => e.check_status);


            var salary_grant_details = modelBuilder.Entity<salary_grant_details>();
            salary_grant_details.ToTable("salary_grant_details");//映射的表名
                                                                 //配置表中的列名设置
            salary_grant_details.Property(e => e.salary_grant_id).HasMaxLength(300);
            salary_grant_details.Property(e => e.human_id).HasMaxLength(300);
            salary_grant_details.Property(e => e.human_name).HasMaxLength(300);
            salary_grant_details.Property(e => e.bouns_sum);
            salary_grant_details.Property(e => e.sale_sum);
            salary_grant_details.Property(e => e.deduct_sum);
            salary_grant_details.Property(e => e.salary_standard_sum);
            salary_grant_details.Property(e => e.salary_paid_sum);
        }

        public DbSet<config_file_first_kind> config_file_first_kind { get; set; }
        public DbSet<config_file_second_kind> config_file_second_kind { get; set; }
        public DbSet<config_file_third_kind> config_file_third_kind { get; set; }
        public DbSet<config_major> config_major { get; set; }
        public DbSet<config_major_kind> config_major_kind { get; set; }
        public DbSet<config_public_char> config_public_char { get; set; }
        public DbSet<type> type { get; set; }
        public DbSet<users> users { get; set; }
        public DbSet<engage_major_release> engage_major_release { get; set; }
        public DbSet<engage_resume> engage_resume { get; set; }
        public DbSet<engage_interview> engage_interview { get; set; }
        public DbSet<Role> Role { get; set; }
        public DbSet<RolPermissions> RolPermissions { get; set; }
        public DbSet<human_file> human_file { get; set; }
        public DbSet<salary_standard> salary_standard { get; set; }
        public DbSet<salary_standard_details> salary_standard_details { get; set; }
        public DbSet<major_change> major_change { get; set; }
        public DbSet<salary_grant> salary_grant { get; set; }
        public DbSet<salary_grant_details> salary_grant_details { get; set; }
    }
}
